OK I have tried a number things including running the following line of code in analyzer:

EXEC master..xp_cmdshell 'ftp -s:c:\ftpSend.txt'

here are the results:

User (209.63.127.202:(none)):

NULL

NULL

cd images

cd pdf

put Q:\Shared\GRIPA\WebDevelopment\GRIPAWEB\images\PDF\08042003_Alerts.pdf

quit

Not sure why Im...

Thanks I did not see that. I have however run the script and it runs however it does not produce a file and I definatley have records that meet that...

I have a query that includes a total of 11 joins all of which are joining on int. 3 of the JOINS are on different databases (same server)and one table...

Is there any way we could see the DTS package? IS the data that your getting an append to your table or a truncate to the table? Why are there...

What kind of job is it?

I did think about doing that. That way I could set the two fields that are giving me the problems to varchar and then I could transform the data back...

Still no go. There’s got to be a way to Loop through each record before it inserts it into the table. I was looking for a way to do this...

But won't that in fact adjust the way all the data is being entered into the table? For instance if I know that field A could possibly be either the...

I did a little research and came up with the following after typing in Cariage Return in Books Online

Control character Value

Tab CHAR(9)

Line feed CHAR(10)

Carriage return CHAR(13)...

Thanks Bruce for your input. I beleive that I had accually created another post under general asking the same question. Here is the link incase you were curious.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=5553&FORUM_ID=23&CAT_ID=2&Topic_Title=XP%5FSENDMAIL&Forum_Title=General

...

We use file exists in all are packages and to take it a step further we have designed each package to do meet one of the 3 variables:

1) If data...

Thanks folks I decided that I would reconfigure the individual tasks in the package to make this thing work. Thanks for your responses!!!

HOWEVER one other question – Looking for script...

I guess I answered my own question!

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=5084&FORUM_ID=19&CAT_ID=3&Topic_Title=Start+or+stop+a+DTS+package+from+running+using+SQL&Forum_Title=Data+Transformation+Services+%28DTS%29

Well I think this will do it however I’m sure they’re maybe another way.

The 1st thing I did was to create a Global variable: gvQueryCount

I made sure not to give...

Well since my original posting my question really has come to fruition. Let me try again:

I have created a Dynamic Property task that creates a Global variable using a SQL...