Increasing performance of SSIS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Increasing performance of SSIS

Author

Topic

AnuVijay
Starting Member

32 Posts

Posted - 2011-10-20 : 04:05:36

Hi

I am having 12 package for dbf files for different products. Each are exporting data into 12 tables in sql server. I would like to automate this job on daily basis.

Can i create a job in sql server agent and schedule it on same time?

Please help me.

Rgds
Ananthi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-20 : 04:21:12

yep. you can
create a job with 12 steps to call the package and assign it a schedule as per your need

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

AnuVijay
Starting Member

32 Posts

Posted - 2011-10-20 : 06:01:03

My SSIS is running very slow to import dbf data into sql server destincation table. I have 1500 dbf files. totally 45 GB of data. It's taking 35 hours to import into sql server table.

I am using for each loop container having data flow task and execute sql task

can u pls help me to increase the performance?

Rgds
Ananthi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-20 : 06:19:32

are you using fast load option?

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

AnuVijay
Starting Member

32 Posts

Posted - 2011-10-20 : 07:34:57

no. am not using fast load option. Also there is only 10 GB free space available on C drive. Do we need to increase the memory of C to increase the performance?

Thanks
Ananthi

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-20 : 07:59:20

nope. how many memory you've allocated to sql server?

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

AnuVijay
Starting Member

32 Posts

Posted - 2011-10-20 : 08:49:51

could you please let me know, how to check the memory allocated to sql server?

Thanks
Ananthi

AnuVijay
Starting Member

32 Posts

Posted - 2011-10-20 : 08:52:15

VM Reserved 12699640
VM Committed 11765956
Locked Pages Allocated 0
Reserved Memory 1024
Reserved Memory In Use 0

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources