Unanswered: SQL DTS Job Fails where Execute of package works?
I have a SQL DTS package that imports a text file as one wide column into a two column SQL table, one is an identity seed. So essentially I import then parse the data using the index key as it is 3 seperate lines of data. All works fine by running the DTS package using execute. When I schedule this as a job it fails. It indicates that I have additional white space after a column. Any thoughts on why this can ocurr?
In testing I navigated to the text file, which is on a share on our ftp site server. I did not change the naming convention back to the server name share name syntax. Once done all went well.