I am having a problem with paramters in DTS. I have an Execute SQL task that takes a count from a table. I then put that count into an output paramter. I then have another Execute SQL task to insert that count into another table in another database using an input parameter. The output of the count seems to work OK because I used an ActiveX script to display the count in a message box and it is correct. However, when I try to do the insert, I only get the first 3 numbers of the count. For example, the count is 899160 and only 899 gets inserted. I've tried integer vs. string data types and that hasn't made a difference. The lenght of the destination column is a varchar 500 so it's not a size issue (I even hard-coded the value 123456789 and the insert worked fine). Help!

I worked with this more today and found a solution. In my original insert statement I was not specifying the column names (i.e. Insert into tablename values (....)). Once I specified the column names it inserted the entire number (i.e insert into tablename (col1, col2, col3) values (1,2,3))

----- April wrote: ----

I am having a problem with paramters in DTS. I have an Execute SQL task that takes a count from a table. I then put that count into an output paramter. I then have another Execute SQL task to insert that count into another table in another database using an input parameter. The output of the count seems to work OK because I used an ActiveX script to display the count in a message box and it is correct. However, when I try to do the insert, I only get the first 3 numbers of the count. For example, the count is 899160 and only 899 gets inserted. I've tried integer vs. string data types and that hasn't made a difference. The lenght of the destination column is a varchar 500 so it's not a size issue (I even hard-coded the value 123456789 and the insert worked fine). Help!