SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to import dbf files with SSIS in a directory
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

salliven
Starting Member

Hungary
3 Posts

Posted - 12/09/2011 :  03:55:13  Show Profile  Reply with Quote
Hello!

I want to import dbf files with SSIS package in a directory.
I created SSIS package with http://dataintegrity.wordpress.com/2009/10/02/converting-dbf-files/
But, how to more dbf files import to a table of SQL Server with SSIS package?


Thanks!

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/09/2011 :  04:12:01  Show Profile  Reply with Quote
you can use for each loop to loop through dbf files
then use a data flow task with microsoft jet provider source to connect to dbf file and oledb connector to connect to sql table for the transfer. give name of table as filename

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/09/2011 :  04:14:27  Show Profile  Reply with Quote
also see
http://msdn.microsoft.com/en-us/library/aa337084.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

salliven
Starting Member

Hungary
3 Posts

Posted - 12/10/2011 :  06:22:45  Show Profile  Reply with Quote
Hello!

Thanks your replay.
Please see this link: http://salliven.site11.com/dbf_load/
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/10/2011 :  11:42:41  Show Profile  Reply with Quote
destination table is name of file and database is name of folder for DBFs

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

salliven
Starting Member

Hungary
3 Posts

Posted - 12/12/2011 :  02:43:29  Show Profile  Reply with Quote
Thanks your replay!

I created two new variables:
1.) @FileName = REPLACE(@[User::FileFullName] , "C:\\adatbetoltesek\\tavszall\\betoltetni\\dbf", "") (Result Exapmle: tavszall.dbf)
2.) @PathName = REPLACE(@[User::FileFullName] , @[User::FileName] , "") (Result Exapmle: C:\\adatbetoltesek\\tavszall\\betoltetni\\dbf)

Please help me, whither I write them?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 12/12/2011 :  09:13:20  Show Profile  Reply with Quote
sorry didnt understand whats the purpose of these two variables? is your dbf file source changing? are you trying to iterate through a set of fileS?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000