Viewing 15 posts - 1 through 15 (of 4,271 total)
Provided you have a fairly good sized VM I am curious if instant file initialization is enabled? I know this can make a HUGE difference in how long it takes...
April 29, 2024 at 7:24 pm
As far as I know there is no way, DTS is no longer supported. In short, you are going to have to rewrite the packages. given that DTS...
October 16, 2015 at 2:47 pm
That's right, I was: http://www.sqlservercentral.com/Forums/Topic1727952-148-1.aspx
CEWII
October 15, 2015 at 9:15 pm
Sushant Yadav (10/15/2015)
Yes they are on different SAN storage.Few databases are on EMC SAN storage and TempDB is on NETAPP SAN storage.
Since it is reporting problems with the tempdb location...
October 15, 2015 at 8:55 pm
Why don't you put a break point on the first statement and step through it. I seem to remember this same discussion yesterday with the same package.
CEWII
October 15, 2015 at 8:53 pm
Always be cautious of audit recommendations, most companies literally have a template that they follow. TDE is an enterprise edition feature so if you aren't running EE then you can't...
October 15, 2015 at 2:59 pm
I'd first start and find out what is going on with the tempdb database. is the disk it is on different than the rest of the databases?
CEWII
October 14, 2015 at 11:32 pm
SSIS packages are created in BIDS and connection strings can be changed a number of places. Please refine the question, it is to unspecific.
CEWII
October 14, 2015 at 11:30 pm
kd11 (10/14/2015)
October 14, 2015 at 11:28 pm
Are you doing this on premises? Or someplace like Azure?
Honestly a clone makes me nervous. Transferring the databases themselves is easy, backup and restore. The credentials is...
October 14, 2015 at 11:26 pm
First, I'm not sure you need "user::" in the variable name. I don't usually include it. I would add a breakpoint at:
string filepath = Dts.Variables["user::var_file_path"].Value.ToString();
And then step through...
October 14, 2015 at 5:23 pm
Ok, just a moment, I didn't have the script and screen shot when I was typing that..
CEWII
October 14, 2015 at 5:20 pm
sowmyapasala5 (10/14/2015)
Well I am trying to load a folder which contains same structured file (same column count, order and information) in three different format (.xls, .xlsx & .txt)....
October 14, 2015 at 5:19 pm
SQL Engine and SSAS can be installed in a multi-instance configuration. However SSIS can NOT, there can be only one! (sorry was channeling the Kurgan)
A lot of your question...
October 14, 2015 at 5:10 pm
You will have to export them to DTSX files. The export is a non-destructive process in that the package is not removed or changed in MSDB. However, it...
October 14, 2015 at 5:00 pm
Viewing 15 posts - 1 through 15 (of 4,271 total)