run

DBCC CLEANTABLE (0,

)

What if you set the variable to Evalute as expession?

Other wise, is the file being brought over from the ftp? if so, rename it once its your side?

Not sure if this will help. I used a WMI connection to get map info from google.

Not sure if this will solve your issue.

Create a connection and copy the connect string from properties.

Add a new variable and call it ParameterString of type string. Paste the connection...

Heya, havent worked on Crystal for years. formating is a pain. IIf I understand the issue correrctly, check your printer settings and make a few changes. see if that changes...

I have used a script task to run a regular expression against incoming data to remove specifed characters.

Would that help?

What about controlling the connection with an expretion?

Hi Stev, sorry. never got that far.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Script Component 1" (212) failed with error code 0x80131500 while processing input...

Thanks Rob, trying VIM to see what the files look like.

Hi Rob, yes, I have been using LF and CR to remove the LF from the end of each row but the last row in a file is not imported....

Hi, thanks for the reply.

we originally were using a script to pick up the files and build staging tables based on the file content and then use bcp to load...

Thanks opc,

that is the article I used to dev with and then I tried all different options.

i ORIGINALLY USED

SELECT *

FROM __InstanceCreationEvent WITHIN 1800

WHERE TargetInstance ISA 'CIM_DataFile'

AND...

Hi guys, been a bit busy.

I couldnt spend any more time on it.

I re-devd the package to do everything in the controller. It doesnt call any packages.

Not very elegant, but...

Both, but mostly yours, thanks Henrico.

Me too