Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 8,191 through 8,205 (of 11,678 total)

RE: Microsoft VSTA SDK

johnitech.itech (2/1/2012)
😀
see important note link below
http://msdn.microsoft.com/en-us/magazine/cc188712.aspx
:hehe:
I fail to see what SSRS has to do with the problem...

February 1, 2012 at 1:01 pm

#1441406
RE: SSIS Microsoft Connector 1.1

dharmbir.kumar 17056 (1/31/2012)
Can anybody let me know if Microsoft connector supports SAP BW 7.x Datasource or not?
The Microsoft® SQL Server® 2008 R2 Feature Pack says
The Microsoft Connector for SAP BW...

February 1, 2012 at 5:21 am

#1441147
RE: SSIS SCENARIO

You don't have the option to choose Excel 2007?

February 1, 2012 at 5:16 am

#1441141
RE: foreign key

happycat59 (2/1/2012)
Yes, the unique contraint would need to be on the Country table - no information supplied on the definition of that table so I gave a generic reply
There is...

February 1, 2012 at 5:14 am

#1441136
RE: Are the posted questions getting worse?

MysteryJimbo (2/1/2012)
Koen Verbeeck (1/31/2012)
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
Agree.
Just...

February 1, 2012 at 5:10 am

#1441133
RE: SET option hierarchy

naresh.cherukumalli 33439 (2/1/2012)
The correct answer can be : option 4
A hint overrides a SET option.

February 1, 2012 at 12:49 am

#1441056
RE: foreign key

happycat59 (1/31/2012)
For a foreign key to be created you must have a constraint that forces uniqueness on some column(s). This could be a unique primary key or a unique...

January 31, 2012 at 11:29 pm

#1441046
RE: SSIS Flat file

Derived column expression:
(myColumn == "NA" || myColumn == "") ? (DT_STR,2,1252) 0 : myColumn
You probably need to keep it as a string datatype, as blank and NA are strings,...

January 31, 2012 at 11:25 pm

#1441045
RE: SET option hierarchy

As pointed out above, the 3rd and 4th answer are mutually exclusive.
So "all of the above" is pretty impossible.
But I like the question in itself.

January 31, 2012 at 11:19 pm

#1441044
RE: Are the posted questions getting worse?

Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
Agree.
Just because you're paranoid,...

January 31, 2012 at 11:08 pm

#1441042
RE: SSIS Package does nothing when scheduled as a SQL Agent job

daniel.nix (1/31/2012)
I figured it out. The server that the files exist on has been mapped to a network drive letter, and I used that letter to specify the path...

January 31, 2012 at 11:03 pm

#1441041
RE: export to CSV file without column headers

vardan.hakopian (1/31/2012)
Yes.Finaly!!!!!!!!!!!!!!!!!!
Ok.here are the steps i did:
Create Credentials
Create Proxy
From Export Data i saved SSIS in MSDB(instead of file system)
Create Agent job using Proxy account.
Thank you very much for your time...

January 31, 2012 at 11:00 pm

#1441040
RE: SSIS Package does nothing when scheduled as a SQL Agent job

daniel.nix (1/31/2012)
Okay after looking at logging, it seems that the forEach file enumerator is showing up with no matches, even though there are matching files in the directory. This...

January 31, 2012 at 2:51 pm

#1440978
RE: SSIS Package does nothing when scheduled as a SQL Agent job

daniel.nix (1/31/2012)
The package is all SSIS components, with one script task. The header and the data are divided from the (oddly structured) .csv's into two temp tables, and then...

January 31, 2012 at 2:40 pm

#1440973
RE: Changing Data Source in Visual Studio Package

guerillaunit (1/31/2012)
Hi,
I have a Visual Studio package that pulls data from an Access table and imports it into my SQL server. The database that the Access table resides in...

January 31, 2012 at 1:43 pm

#1440949

Viewing 15 posts - 8,191 through 8,205 (of 11,678 total)