Viewing 15 posts - 61 through 75 (of 87 total)
Phil Parkin (11/17/2013)
Have a look at this page. All sorts of useful info on limits there, including max. batch size.
Maximum Capacity Specifications for SQL Server....I'll keep that in mind and...
November 18, 2013 at 12:16 am
Phil Parkin (11/17/2013)
I have a string variable which stores a big set of sql statements, ie insert statements. The insert statement intends to inserts about 200K rows with 10 columns...
November 17, 2013 at 4:14 pm
Koen Verbeeck (11/12/2013)
Exploring the System.Object Package Variable[/url]
2. You can either iterate it using a for each...
November 15, 2013 at 12:10 am
Here is the answer -
http://stackoverflow.com/questions/19867490/how-to-make-a-transaction-in-my-case
November 8, 2013 at 1:50 pm
GilaMonster (11/7/2013)
blasto_max (11/7/2013)
I want sql server to create a number and put it in ID when i insert a row into the table. How do I do it ?
Exactly as...
November 7, 2013 at 3:37 pm
GilaMonster (11/7/2013)
ID BIGINT IDENTITY NOT NULL
I used IDENTITY(1,1) only before and it said cannot insert null into ID. Clearly, it does not meet my requirements. I want sql server to...
November 7, 2013 at 1:09 pm
Raunak Jhawar (11/7/2013)
What variables are you talking about? You can delete the SSIS variables you do not require for package execution from the designer by edit the dtsx file
Say you...
November 7, 2013 at 10:07 am
Koen Verbeeck (10/31/2013)
I sincerely doubt it.SSIS packages are executed with dtexec.exe and as far as I know (unless I'm missing something) .exe files cannot run on Linux.
With a shot of...
November 1, 2013 at 11:07 am
Matt Miller (#4) (10/30/2013)
1. the SSIS route - use the flat file connector to make SSIS aware of the generic content. then use a conditional...
October 30, 2013 at 1:33 pm
I am doing only select statements.
Response "to below86" - regarding execute SQL indirectly by executing a bat file which executes SQL - I am trying something similar now. Need...
October 30, 2013 at 10:42 am
Koen Verbeeck (10/30/2013)
Matt Miller (#4) (10/29/2013)
October 30, 2013 at 10:29 am
Answered super fast at the good ol - stackoverflow.com
http://stackoverflow.com/questions/19671214/bulk-insert-task-fails-but-actually-succeeds
October 29, 2013 at 5:58 pm
Okay, this is what I want to do -
Select getDate() from execute SQL -> Load this result set to recordset ABC -> Read ABC and put it into a...
October 28, 2013 at 11:00 am
Viewing 15 posts - 61 through 75 (of 87 total)