• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 505
  • Last Modified:


I have created a simple DTS that has a connection from an excel spreadhsheet into a sql table. One of the transforms isnt working, the column in the excel spreadsheet in in general form, the format in the field in the SQL table is varchar, however it is bringing through datetimes?

1 Solution
Maybe you are assigning a different coloumn to it??

Open Enterprise Manager >> Expand The Data Transformation Services >> Click on Local Packages >> Double Click on your DTS

Now you will see a Gray line going between your Table and excel Double click on that and click on the transformation Tab and make sure everything is going where is supposed to

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now