It depends. How selective is your query to pull the data? If you have a high degree of selectivity (returning only a small portion of the entire table),...

Within your dataflow, use a conditional split and check the value in question for null using the ISNULL function. You can route those values that are NULL to a...

Amith,

Within your ForEach loop container, you can map the filename to a variable. After you extract the data from the file (using a DataFlow within that loop), you can...

In your lookup component,...

If you are using psftp, there is a feature that will prompt you the first time you run the software to put the server's key in your cache. This...

The Lookup Transform will do two things: It will validate rows in your data flow against a given table, and will also (optionally) pick up additional values in the row...

Mark, if I read you correctly you are running into an issue where the absense of a value in the source returns a fixed width 14 character field, which equates...

If you've confirmed that the file source is accessible under the context of the account running SQL Server agent, check the same thing on the destination folder (I assume that...

I've run into this need before, and in most cases the row type was identified by the first element on each row. A row type of 10 might have...

In your Data Flow window, there is a transformation called Row Count. You can use this to write the row count value out to a variable.

You can do this with SSIS, but you'll need to run it through a script component to make it work. Depending on the destination of the rows, you may...

Amy, if you're entering the executable name and the graphical tool is coming up, you're calling the wrong executable. There will be a different EXE file for command-line usage....

I believe you are confusing the raw file destination with the flat file destination. A raw file is a special kind of SQL Server data file storage, and is...

You'll most likely need to use a script task for this, looping through each file in your directory and processing each file in turn.

Hope this helps,

Tim

awelsh (7/9/2008)

---

I opened a command Prompt window and typed pgp -s filename.txt. No, I didn't set up the environment, which is why I suspect it is erroring stating it...