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.
| Author |
Topic |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2009-04-16 : 15:49:30
|
| I'm trying to set up a new job using SSIS. On the general tab for Package I'm not quite sure what needs to go there. My goal is to export a table(oelinhst) to another table in the same database(oelinhst2) I want this to happen every night at 11pm. When I just type a package name in I get an error. "The specified package could not be loaded from the SQL server database" |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-04-17 : 07:58:35
|
| Are you using SQL Agent to schedule the job?Are you just typing the path?Use the buttons to find the package instead of typing it. |
 |
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2009-04-17 : 08:49:22
|
| I guess my next question is How do you set up a package to schedule the export of a table?Any good links? I can't seem to find any that explain how to schedule the export of a table. |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-04-17 : 09:01:06
|
| Here's one but google it for more samples:http://www.mssqltips.com/tip.asp?tip=1180 |
|
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2009-04-17 : 09:59:12
|
| In the SQL Server Business Intelligence Development studio I want to export data from a sql table to a new Sql table. For my source I used OLE DB Source. Do I want to use the same for my destination or do I want to use SQL Server Destination?? |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-04-17 : 10:03:49
|
| Use OLE DB Destination. You can use a Derviced column in between if there are any changes needed to the data.EDIT : Also wanted to mention that, you can use SQL Server destination , but the destination database must be on the same server on which you are executing the SSIS package. |
|
|
|
Vack
Aged Yak Warrior
530 Posts |
Posted - 2009-04-17 : 10:16:35
|
| I'm not manipulating any data. Just moving a block of data to a new table in the same database. I have it setup to use SQL Server Destination. I run the test in the SBIDS and it seems to be fine. I setup a job in SQL Server Management Studio. When I start the job I get:Cannot start the job ExportOELINHSt because it does not have any job server or server defined. Assiciate the job with a job server by calling sp_add_jobserver |
|
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-04-17 : 10:28:42
|
| hmm..Have you checked the "Target Local Server" thingie?maybe this might helphttp://blogs.msdn.com/mwories/articles/smosample_createjob.aspx |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-04-17 : 13:24:34
|
| How about INSERT INTO statement using SQL Task to move your data. |
|
|
|
|
|
|
Scheduling Export