if you right click on the OLE DB and select Advanced Editor, click on the Component Properties tab. Change the ValidateExternalMetaData value to False. This will not validate your string...

have you tried loading the data into a temp table first to just pull the records down from the AS/400 and then move the records from the temp table into...

a quick thought on how to do this would be to have a stored procedure that handles the unique id processing and return the value back in an output parameter....

well, both a package level and object type can be the same variable since you are defining scope (package) and type (object), but that is neither here nor there for...

you can take advantage of the Expressions in the Send Mail task. select Expressions and then click the ellipsis to select which Property you want to setup an Expression for....

if i am reading this correctly, you are looking to take a 3 column spreadsheet and make it into one column in your data flow. if that is the request,...

glad to hear you solved it...

i would not put a wait on the execution, the execute sql task will not fire until all of the other data flows have completed successfully, which is the wait...

at first, i thought that it was a locking issue because your data flow still had control of the file when the script task executed. however, i was able to...

Right click on the OLE DB Data Source object and select Show Advanced Editor and go to the Component Properties tab. For the OpenRowset property, type in the name of...

In the On Error processing, under Error, do you have the Redirect Row option selected or Fail Component? If you select Redirect Row, the error should be written to the...

an initial thought would be to build a data flow task that imports the records from the CSV and then performs a conditional split on the data for the notified...

The Execute SQL task is not going to allow for multiple connections as you can only pick one connection, which would be either the SQL or ORACLE connection from your...

here is a quick example that can get you started:

declare @sql varchar(150), @rec_count int

--hold the temp rec count for the dynamic query into a temp table of the...

one thing to note is the FETCH STATUS check, you should check if it is equal to 0 as opposed to <> -1 since it can return -2 as well,...