Viewing 15 posts - 6,496 through 6,510 (of 13,877 total)
ranala (10/19/2016)
we are working on MS SSIS 2010 version and database version is MS SQL Server 2012. when we are saving SSIS integration services jobs taking very long time....
October 19, 2016 at 6:03 am
mark 4643 (10/19/2016)
Our dev team is growing. We use red-gate toolbox, so we have schema compare, data compare and source control. for the past few years we have used...
October 19, 2016 at 6:01 am
Thom A (10/19/2016)
October 19, 2016 at 5:54 am
While it will probably have little effect, I would suggest reducing the varchar(max) column to something more realistic.
October 18, 2016 at 1:28 pm
Thom A (10/17/2016)
Phil Parkin (10/16/2016)
Your lab would need SQL server 2016 developer, VS2015 SSDT and VS2015 SSDT-BI, so three installs at a minimum. ...
Actually, this bit is not quite correct....
October 18, 2016 at 1:25 pm
dc4444 (10/18/2016)
Yes, I tried increasing it to 2 minutes. But it still fails after the 3rd poll.
Yes, I redesigned the logic so that it uses a "table valued parameter" passed...
October 18, 2016 at 1:21 pm
dbaforever (10/18/2016)
1. I don't see the link you referred to
2. These packages work well on the old 2012 instance (Visual Studio 2012). Are you suggesting I install VS...
October 18, 2016 at 12:05 pm
SQLHeap (10/18/2016)
October 18, 2016 at 11:59 am
sqlfriends (10/18/2016)
yes, sometimes I use stored procedure to return result.So for those, I give user the public role, and grant execute to the stored procedure.
Is that OK?
Thanks,
Not the best....
October 18, 2016 at 11:07 am
ZZartin (10/18/2016)
The easiest way is probably just to add them to the db_datareader group in the database. Assuming you don't need any more granular permissions.
I'd create an AD group,...
October 18, 2016 at 11:06 am
ChrisM@Work (10/18/2016)
mitzyturbo (10/18/2016)
Sorry Chris, forgot to attach the indexesHappy enough to go with the TOP 1 in a CROSS APPLY
Thanks anyway
Here's the ROW_NUMBER version. I think the index I posted...
October 18, 2016 at 10:12 am
dbaforever (10/18/2016)
In the Integration Services 2014 Project Conversion Wizard, it shows Package Status "Not Loaded", "One or more packages are not ready".
Also "Cannot create a task for XML...
October 18, 2016 at 10:09 am
Misha_SQL (11/17/2014)
Quick question...
October 18, 2016 at 9:23 am
sindhupavani123 (10/18/2016)
I need to write a query for teachers who dont have classes on a particular day.
like ex: name, day, courseid
Mary, MON, Science
Surya, TUE ,Maths
Mary, TUE ,Biology
The teacher teach...
October 18, 2016 at 7:57 am
river1 (10/18/2016)
Hello,The ssis as a loop also. It is a forearm loop container.
A what?
October 18, 2016 at 6:53 am
Viewing 15 posts - 6,496 through 6,510 (of 13,877 total)