Search results

Whell actually, because of working with data transformations (importing txt files into sql and transfrom data) is the reason that I need to work into a data flow task. And data flow task I thing that is the best way for manipulating data. Is that so..;

No my friend, Script component is different than 'execute sql task'. You can find it into the data flow task and when you click on the toolbox it is in the data flow transformations.

Hi guys, In a SSIS package i have 5 or 6 script component. Is it possible to write once a function and call it from each script when i need it or do i have to copy my function into each script component? Thanks

I am dealing a new problem and I don’t know if this can be accomplished with query. I have a table like Date b c d 1/01/01 145 202 15 1/01/01 45 78 65 And I want an output like Date f1 f2 1/01/01 b 145 1/01/01 b 45 1/01/01 c 202 1/01/01 c 78 1/01/01 d 15 1/01/01 d 65 I thought about...

I finally make it to work ..!!!! Don’t ask me what cause the problem but I had a bad feeling about executing an sp from the on delete event procedure for x>1 rows. I’m really curious about the results if someone would like to reproduce my problem.. This is what I did.. Evp=event procedure In...

(Sorry for my English i'll try the best i can) ok imagine this.. Let's say that i have a datasheet. In the datasheet the user can choose from recordselectors as many rows as he wants. He selects one row and hit the delete key from his keyboard. The ondelete procedure is executing and the...

ok.. i execute the code but the 'Timeout expires' error message appears again. The on delete event procedure is executing, for the number of rows i've selected to delete. If the number of selected rows is one, then the code is executing with no problem. If the number of selected rows >1, then...

Static cn As New ADODB.Connection Static StrConn As String Static rec As New ADODB.Recordset Static cmd As New ADODB.Command Set cn = Server.CreateObject("ADODB.Connection") StrConn = "Driver={SQL Server};Server=xxx;Database=db;Trusted_Connection= Yes;" cn.Open StrConn cn.CommandTimeout = 0...

I've already add that line but the error remains..

Thanks for your reply.. I copied the code you posted in my mdb. I debug it and there is an error found on Server.CreateObject("ADODB.Connection") and say that variable not found.

What do you think of adding the commit statement in my stored procedure..?

Hi guys, In a datasheet, on the delete event procedure I have the code below: Static StrConn As String Static rec As New ADODB.Recordset Static cmd As New ADODB.Command StrConn = "Driver={SQL Server};Server=xxx;Database=db;Trusted_Connection=Yes;" cmd.ActiveConnection = StrConn...

Yes my friend... thanks to your perceptiveness my function is working! I was passing the wrong parameter to the function..! thanks..

You maybe right... I'll check it and i let you know tomorrow.. Thanks for your reply

Thank for your reply, Actually the workcenter is the name of the field that i want to pass to the function as value. I dont want to pass to the function the word 'workcenter' but the value of the field named workcenter.

Hi guys, All I am trying to do is to execute an SQL Query from SQL Server Management Studio. In one column I’m calling a simple SQL Function. When I execute the function from visual studio to test it, everything works fine. When I execute it from the query returns null :confused:. I ‘ll post...

thank's a lot for your reply and your suggestions :)

I manage to solve the problem by making a job and executing it from Access with sp_start_job. Is there a store procedure that can return the packages are currently running on SQL?

Hi All, I am trying to execute a deployed SSIS package, from Ms Access 2003. Is it possible; thank you

Thanks for your reply but it is not working... I have tried the events of the form and the subform.. I have linked tables to SQL.. I am mentioning this, cause i dont know if i have to deal it with another way...