Click here to Skip to main content
15,868,164 members
Home / Discussions / Database
   

Database

 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs13-Jul-11 5:03
kmoorevs13-Jul-11 5:03 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
jschell13-Jul-11 9:05
jschell13-Jul-11 9:05 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:04
smcnulty200014-Jul-11 23:04 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:01
smcnulty200014-Jul-11 23:01 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 6:06
kmoorevs15-Jul-11 6:06 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 7:11
kmoorevs15-Jul-11 7:11 
Questiondeploying an SSIS package to server Pin
Alaric_7-Jul-11 8:23
professionalAlaric_7-Jul-11 8:23 
AnswerRe: deploying an SSIS package to server Pin
Alaric_7-Jul-11 16:09
professionalAlaric_7-Jul-11 16:09 
ok...I've got the thing deployed, but I'm trying to run it from a job. If my job is running in a database called "dev" and a package named "foo" is running in Integration Services on "dev", how would I go about referencing it in my job step command?

(just a stab)
EXEC @ReturnCode = msdb.dbo.sp_add_jobstep @job_id=@jobID, @step_name=N'Execute SSIS package',
     @step_id=1,
     @command=N'/FILE "\\dev\MSDB\Maintenance Plans\foo.dtsx" /CHECKPOINTING OFF /SET \Package.Variables[User::Correlator].Properties[Value];' + @Correlator + ' /REPORTING E'


Looking at my @command assignment, is anything missing?

I have the thing deployed to MSDB\Maintenance Plans, but I really don't know if the reference is as simple as this.

..Is it? I'm getting an "XML Parsing error"(<-pseudo) that seems to be a permissions error when trying to open the package. Either the package doesn't exist at the location specified or my account doesn't have access to the file...I'm pretty confident that I have access to the file, so my other logical option is that the context that I have provided in my snippet above is incorrect.

Does anyone know how I should go about referencing it?
"I need build Skynet. Plz send code"

AnswerRe: deploying an SSIS package to server Pin
thatraja8-Jul-11 16:49
professionalthatraja8-Jul-11 16:49 
GeneralRe: deploying an SSIS package to server Pin
Alaric_11-Jul-11 2:24
professionalAlaric_11-Jul-11 2:24 
QuestionHow to store audio, vedio, Image file in SQL server Pin
monulove2u7-Jul-11 4:21
monulove2u7-Jul-11 4:21 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
Blue_Boy7-Jul-11 4:34
Blue_Boy7-Jul-11 4:34 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
Ravi Sant7-Jul-11 4:47
Ravi Sant7-Jul-11 4:47 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
PIEBALDconsult7-Jul-11 14:34
mvePIEBALDconsult7-Jul-11 14:34 
GeneralRe: How to store audio, vedio, Image file in SQL server Pin
Mycroft Holmes7-Jul-11 22:04
professionalMycroft Holmes7-Jul-11 22:04 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
jschell8-Jul-11 12:23
jschell8-Jul-11 12:23 
AnswerRe: How to store audio, vedio, Image file in SQL server Pin
nilesh ubhe11-Jul-11 18:54
nilesh ubhe11-Jul-11 18:54 
QuestionSSIS: Trying to update a subset of columns in an Ole Db Destination from a flat file source Pin
Alaric_6-Jul-11 2:15
professionalAlaric_6-Jul-11 2:15 
Questionis it possible restore file( which back up in ms-sql2008) to ms-sql 2005? Pin
buffering835-Jul-11 23:50
buffering835-Jul-11 23:50 
AnswerRe: is it possible restore file( which back up in ms-sql2008) to ms-sql 2005? Pin
scottgp6-Jul-11 1:35
professionalscottgp6-Jul-11 1:35 
AnswerRe: is it possible restore file( which back up in ms-sql2008) to ms-sql 2005? Pin
Shameel6-Jul-11 21:48
professionalShameel6-Jul-11 21:48 
QuestionDeadlock problem Pin
Y_Kaushik5-Jul-11 19:18
Y_Kaushik5-Jul-11 19:18 
SuggestionRe: detecting and ending Deadlocks Pin
David Mujica6-Jul-11 3:08
David Mujica6-Jul-11 3:08 
AnswerRe: Deadlock problem Pin
MecAlex10-Jul-11 22:40
MecAlex10-Jul-11 22:40 
QuestionMySQL in-memory table vs. SQLite in-memory DB Pin
GregStevens5-Jul-11 17:32
GregStevens5-Jul-11 17:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.