Viewing 15 posts - 6,481 through 6,495 (of 13,874 total)
DamianC (10/20/2016)
Thanks for the responseHow would I use a foreach Loop if the files are structurally different?
Good point. I did not read your initial post closely enough!
But it is still...
October 20, 2016 at 9:30 am
Jeff Moden (10/20/2016)
Phil Parkin (10/20/2016)
First point to note is that a CSV file is a far far better thing to be importing from than an Excel file.
"It Depends". ...
October 20, 2016 at 8:06 am
jasona.work (10/20/2016)
Brandie Tarvin (10/20/2016)
I don't quite feel your pain, but I'm in the midst of migrating a handful of DBs to a new server. One is ~134GB of data,...
October 20, 2016 at 7:57 am
DamianC (10/20/2016)
I'm using a data flow task to convert a number of csv source files into a number of SQL tables
Ideally, I want to ensure that the number of rows...
October 20, 2016 at 7:16 am
ranala (10/20/2016)
we are loading data as like below. Please help asap.
1. reading data from MS Excel and CSV
2. applying filters to load...
October 20, 2016 at 6:10 am
rocky_498 (10/19/2016)
After I receive email.I am seeing only "Please Click :" in the email body.Which link?
The one hyperlinked by the word 'this'.
October 19, 2016 at 2:40 pm
What happens when running with the code you posted? Does the hyperlink appear at all?
Your HTML syntax is a little bit wrong. Check this page.
October 19, 2016 at 1:35 pm
Aatish Patel (10/19/2016)
I need some clarification on setting up SQL mirroring between different version of SQL Server. Can we setup mirroring between SQL Server 2008 R2 to SQL...
October 19, 2016 at 9:08 am
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
Viewing 15 posts - 6,481 through 6,495 (of 13,874 total)