Modify the flat file source in the Connection Manager in your SSIS package. Tell it to use a double quote as the text qualifier.

Are you sure there isn't something else going on causing that row to fail?

You could simply modify your flat file source by telling it to use the double...

You're using SQL syntax in an Active X Script task. That obviously won't work.

Simply change the line to

DTSDestination("Failure_PO_Create_Date") = DTSSource("po_create_date").

If the data in the varchar field is actually a date,...

I can think of 2 ways of doing this, I'm sure there are others.

First way would be to change the DTSTransformStat_SkipRow constant in your Active X transformation script task to...

So, which of those lines is line 13? Find it and make sure the data type in both the source and destination table is the same.

Do you want to populate a Global Variable with the result of an Execute SQL Task or do you want to use a Global Variable as a parameter in the...

Open the file in Visual Basic.

Add the following References to the VB project:

Microsoft DTSPackage Object Library

Microsoft DTS Custom Tasks Object Library

Microsoft DTS Runtime 1.0

Microsoft DTSDataPumpScripting Object Library

You may not need...

What does the Active X script task do?

It's most likely a permissions issue. When you run the package, it uses your login's permissions. When scheduled in a job,...

Execute SQL Tasks don't like SQL statements that have parameters and also do things like create & drop tables.

Easiest fix is to create a stored procedure that executes these statements,...

Right-click in the empty space of your DTS package and select Disconnected Edit. Expand the Steps section, find your step and change the Name & Description properties.

Look up the GetExecutionErrorInfo method of the DTS Package Step object in Books online.

An example can be found in the .zip download at http://www.sqlmag.com/Article/ArticleID/6196/sql_server_6196.html.

If you can assume that one asterisk means bad data, then why not just use the LEFT function?

If Left(DTSSource("Col031"), 1) = "*" Then

I would use the WshNetwork object to map a network drive to the UNC path.

Function Main()

Dim objFSO

Dim WshNetwork

Dim strDriveLetter

Dim intCounter

Dim strLetters

Dim strAttemptedLetter

Set objFSO = CreateObject("Scripting.FileSystemObject")

Set WshNetwork = CreateObject("Wscript.network")

strLetters = "efghijklmnopqrstuvwxyz"

intCounter...

Sounds to me like you need to add an Execute Package Task to your 2nd DTS package that will execute the 1st package. Pass the value of the global...

What are the Workflow property settings between your Active X script task and the next task?

Check the Workflow propeties on the next step of the package. Right-click on the task,...