![]() ![]() Once in the connection manager i'm entering the location C:\Temp\test and going in the advanced section and changing the extened properties to DBASE IV. The connection I'm currently using is to get to the files is the Native OLE DB\Microsoft Jet 4.0 OLE DB Provider. In order to view the data I need both files in the same folder so I would assume it is a database file. Yet what I do know is I'm recieveing two files in a zip. I don't much information about the files themselves due to their coming from an external company to ours. Archived name will change the file to yyyymmdd.Ĭan someone help me do this dynamically.I've wasted a day trying trying to do this. dbt) into a folder to be renamed and archived. dbf files have been inserted into the table move all files (.dbf and. dbf file hard coded yet won't let me do multiple files.ģ.) Once all. dbf) and the data will be inserted into a staging table in sql sever 2008. Here is a list what I need this package to do.ġ.) Truncate the staging table in SQl Server 2008 - No issuesĢ.) foreach loop to pull data from 1 dbf files(file names will never be the same.yet will always. I've followed all the directions for both of the links below yet I'm unable to use a variable name with a blank variable name as they state. ![]() I've recently started using Sql Server SSIS packages and I'm having an issues importing more then one dbf file from a network drive into a sql table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |