Is the AlwaysUseDefaultCodePage property set to True on the AS400 Data Source Task?

Which driver is being used, IBM's OLEDB or MS OLEDB for DB2?

Also examine the CCSID for column using...

Does the data need to be loaded in the table first?

The Conditional Split Transform can be configured to check to the column value = US and only load those rows....

Take a look at this article. It gives a detailed step by step.

http://www.sqlservercentral.com/articles/Integration+Services/61542/

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Hi Andrew,

I've not done this myself, but I have seen some articles on using the Slowly Changing Dimension to to this type of thing. Many folks are complaining about performance...

I tried Peter's expression. It works correctly.

It sets the variable to: SELECT 1207

What is the error that BIDS is throwing?

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Right click on the OLE DB data source and hit Show Advanced Editor. Look at the Input and Output Properties tab. Expand the External Columns. The data type can be...

Does this work?

select @cmd = 'dtexec /server simsqlwds01 /sql "\SIMSQLWDS01\DTS Packages\DTS Packages\FCE_Costing_Load1\CSV_to_Spell_STG"

/SET "\Package.Variables[user::p1].Properties[Value]";'+"FilePath"

I am assuming that FilePath is a column in a table?

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Vijay,

The utility DTS Package Seach will do what you need to do and handle file based packages with passwords. The advanced search feature will allow you to search at the...

... SSIS service uses an authorized service account

What does that mean?

Are all services on both machines running under domain accounts?

Norman

DTS Package Search

http://www.dtspackagesearch.com/

How about changing the query to return the next file name using the T-SQL date functions. Store the result in a SSIS package variable and set the FTP Task up...

This should get you started. Page 2 especially has the task enable/disable method.

http://www.sqldts.com/218.aspx

Norman

DTS Package Search

http://www.dtspackagesearch.com/

What's the error message?

Query the sysfiles table in the database to be shrunk before and after the operation.

Norman

DTS Package Search

http://www.dtspackagesearch.com/

Hi Pat,

>It runs under specifice id which is part of Admin group on the server!!

Is that id a domain account? It's local admin on which server? SSIS or DB or...

A problem with your workstation?

Use the profiler and sp_who2 to see what is going on at the server where the package is being saved.

Norman

DTS Packaeg Search

http://www.dtspackagesearch.com/

Hi Imke,

Here are a couple links with good articles

http://blogs.msdn.com/sqlcat/archive/2006/05/19/602142.aspx

http://msdn2.microsoft.com/en-us/library/aa196739(SQL.80).aspx

Google this for more: bcp parallel data load

How is the source table architectured. One table with 180...