Is there a way to automate the manually inserted data i ssis pls le me know

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Is there a way to automate the manually...

Is there a way to automate the manually inserted data i ssis pls le me know

Rate Topic

Display Mode

Topic Options

Author

Message

swetha.prachi

Posted Monday, October 01, 2012 1:26 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 15, 2013 5:28 AM
Points: 15, Visits: 41

I hav inserted some records manually into the target table but we dont want that we want to automate the insertion of data how can i do that in ssis 2008 pls help me in this

Post #1366342

anthony.green

Posted Monday, October 01, 2012 1:48 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Where is your data coming from?

Once we know that we can say if SSIS will perform the tasks needed to import the data for you.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1366350

swetha.prachi

Posted Monday, October 01, 2012 2:02 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 15, 2013 5:28 AM
Points: 15, Visits: 41

We are getting it from the sql database

Post #1366369

anthony.green

Posted Monday, October 01, 2012 2:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Then yes, SSIS will be able to read data from 1 database then insert it into another database.

Post #1366372

swetha.prachi

Posted Monday, October 01, 2012 2:13 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 15, 2013 5:28 AM
Points: 15, Visits: 41

I will tell you what v hav done it so u can get clear idea what i'm trying to ask
v hav pulled some records frm different source tables by joining them
and v hav to add some records manually to the target table based on the granularity level lik depending on region, country, city, state etc for the same records in the target table v r providing some condition and v r inserting it to target table.

this v want to automate it how to do tat?
i hope i hav not confused u Smile

Post #1366380

anthony.green

Posted Monday, October 01, 2012 2:15 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

If you know the logic and the joins and have the SQL statements to do all the work, you just need to use the data flow tasks and supply the task with the SQL statement which generates the data then link it to the destination table.

Post #1366381

swetha.prachi

Posted Monday, October 01, 2012 3:20 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 15, 2013 5:28 AM
Points: 15, Visits: 41

k thanks a lot for ur suggestion

Post #1366412

« Prev Topic | Next Topic »

Permissions