Click here to Skip to main content
15,307,395 members
Home / Discussions / Database
   

Database

 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 5:39
Membersmcnulty200015-Jul-11 5:39 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 7:48
professionalShameel15-Jul-11 7:48 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 8:08
Membersmcnulty200015-Jul-11 8:08 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 2:44
MemberAnnieMacD15-Jul-11 2:44 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200014-Jul-11 23:20
Membersmcnulty200014-Jul-11 23:20 
QuestionTemp and variable table cannot be created. Pin
Groulien10-Jul-11 22:27
MemberGroulien10-Jul-11 22:27 
AnswerRe: Temp and variable table cannot be created. Pin
Shameel11-Jul-11 1:42
professionalShameel11-Jul-11 1:42 
AnswerRe: Temp and variable table cannot be created. Pin
DaveAuld11-Jul-11 2:57
professionalDaveAuld11-Jul-11 2:57 
Sounds like the account you are using from the SSIS package does not have the correct permissions compared to the account you are using while connected via SQLSMS.

Have you added logging into your SP so any errors get written to the SQL Event Logger (there are maybe errors already being logged which will give you a clue).
Dave
Find Me On: Web|Facebook|Twitter|LinkedIn

Folding Stats: Team CodeProject

AnswerRe: Temp and variable table cannot be created. Pin
Corporal Agarn11-Jul-11 6:00
professionalCorporal Agarn11-Jul-11 6:00 
AnswerRe: Temp and variable table cannot be created. Pin
S Douglas11-Aug-11 10:07
professionalS Douglas11-Aug-11 10:07 
QuestionRestoration of publisher database to another system (merge replication) Pin
Abd.Jabbar9-Jul-11 21:39
MemberAbd.Jabbar9-Jul-11 21:39 
AnswerRe: Restoration of publisher database to another system (merge replication) Pin
Corporal Agarn11-Jul-11 3:28
professionalCorporal Agarn11-Jul-11 3:28 
QuestionWho owns the data/database? Customer or vendor? Pin
kmoorevs9-Jul-11 5:55
Memberkmoorevs9-Jul-11 5:55 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
Mycroft Holmes9-Jul-11 13:13
professionalMycroft Holmes9-Jul-11 13:13 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
PIEBALDconsult10-Jul-11 6:32
professionalPIEBALDconsult10-Jul-11 6:32 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs11-Jul-11 9:14
Memberkmoorevs11-Jul-11 9:14 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
jschell12-Jul-11 11:08
Memberjschell12-Jul-11 11:08 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs13-Jul-11 5:03
Memberkmoorevs13-Jul-11 5:03 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
jschell13-Jul-11 9:05
Memberjschell13-Jul-11 9:05 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:04
Membersmcnulty200014-Jul-11 23:04 
AnswerRe: Who owns the data/database? Customer or vendor? Pin
smcnulty200014-Jul-11 23:01
Membersmcnulty200014-Jul-11 23:01 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 6:06
Memberkmoorevs15-Jul-11 6:06 
GeneralRe: Who owns the data/database? Customer or vendor? Pin
kmoorevs15-Jul-11 7:11
Memberkmoorevs15-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 

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.