Viewing 15 posts - 7,381 through 7,395 (of 13,882 total)
Still unable to manually run the package from SSIS Catalog from remote SSMS
When you try this, are you connected to the SQL instance via Windows Authentication or SQL Authentication?
March 23, 2016 at 2:43 pm
Install the 32-bit drivers too, assuming they exist, then SSDT will use those.
When the packages run on the server, they will use the 64-bit versions.
March 23, 2016 at 2:41 pm
Probably because SSDT is a 32-bit client 🙂
March 23, 2016 at 2:03 pm
It really seems that the Agent service account does not have the necessary rights.
Are you using a UNC path?
March 23, 2016 at 2:01 pm
jasona.work (3/23/2016)
March 23, 2016 at 12:13 pm
SQL!$@w$0ME (3/23/2016)
Any thoughts on this.
Many...
March 23, 2016 at 12:11 pm
db8 (3/23/2016)
i need suggestion on this error
Truncation may occur due to inserting data from data flow column "name"
with a length of 50 to database column "name"...
March 23, 2016 at 11:11 am
As far as I know, you can set yourself up with an EC2 instance (Windows Server only) and then install whatever you like.
March 23, 2016 at 3:05 am
Eduardo Olivera (3/22/2016)
I started extended events session to capture that file size change. That would be more to the point than a profiler trace.
I was only trying to help.
March 22, 2016 at 9:59 am
Perhaps you could use Profiler to find out what the app is doing?
March 22, 2016 at 9:04 am
yb751 (3/22/2016)
Jacob Wilkins (3/22/2016)
Steve Jones - SSC Editor (3/22/2016)
Alan.B (3/21/2016)
March 22, 2016 at 9:02 am
Koen Verbeeck (3/22/2016)
Grant Fritchey (3/22/2016)
Koen Verbeeck (3/22/2016)
Grant Fritchey (3/22/2016)
Koen Verbeeck (3/22/2016)
March 22, 2016 at 6:51 am
SQL!$@w$0ME (3/21/2016)
Can the SSISDB database files moved to...
March 21, 2016 at 1:15 pm
Take a quick look here and see whether it may be relevant.
March 21, 2016 at 10:38 am
Those cakes sound tempting:-)
What I suspect is that the TRY_PARSE is merely hiding a more fundamental problem. The fact that you were getting errors before means (I think) that the...
March 21, 2016 at 9:30 am
Viewing 15 posts - 7,381 through 7,395 (of 13,882 total)