That usually means that one of your fields is bigger than how you defined it. Try looking at your input file and see if you can tell which field...

Here is a way to enumerate over the variables in a package. I can get the names and values of the variables but not the other things you would...

Thanks for the tip and happy to help!

Kay Batta

I found an error in the script. Change the query build statement to:

wquery = "update pkid set pkval = " + workpkval.ToString

After the script component, I added a conditional...

How do you distinguish among header/detail/trailer rows? If there is a field that identifies them, you can use it in a conditional split to just keep the detail rows.

Make sure variable pkval has package scope. If not, delete it and add it on the Control Flow page.

Add a string variable on the Control Flow page to hold...

Do a SQL query where you select the value and write it to the variable. My SSIS book at home does not explain how to do this but I...

The data viewer shows both the fields that were input to the script and the output fields. You would just pass the fields you need to the form1 table.

In the control flow task, get the starting value of pkval and put into a variable.

Then call a data flow task.

In the data flow task, select the rows you want...

I did a search in this forum for unzip and came across this article:

http://www.sqlservercentral.com/Forums/Topic299502-148-1.aspx?Highlight=unzip

It might get you started.

I see that as soon as I hit the post reply button, everything I had pasted in was discarded. I guess I have to type.

Here are the missing pieces.

DTS:Variable

DTS:VariableValue...

This documentation sounds like something we would all find useful.

The closest I can find is to right-click on the package in the Solution Explorer and select code. ...

Are you maintaining just one row in the table and updating it with each load?

Is the following example what you have in mind?

currentweekdate = 2008-07-14

(date of run)

lastweekdate = 2008-07-07

(one week...

Here is a way for a child package to change variables in the parent package.

In the child package,

1. Define the variables that you need. But DO NOT INCLUDE the...

Thanks! I will give it a try.