Thats not an option. This will eventually be an automated process that will take place daily however I think I may have found the answer. When doing the import in the transformation option "Enable identity insert" was enabled. According to the help by enabling this option and setting...
I'm trying to import a text file into a table with the first columnd setup as an autonumber called "ID" int Identity yes (1,1). When I try and import text data (I do not import the ID field) the import fails indicating that the ID field is a required field and cannot be Null. Any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.