Viewing 15 posts - 10,996 through 11,010 (of 13,872 total)
kk.86manu (12/6/2011)
When SSIS loads data from the text file,are all fields read as string data types, even if they contain integers?Should we convert the data before loading?
Please let me...
December 6, 2011 at 8:52 am
MostInterestingMan (12/5/2011)
I have a package that pulls a csv file from a client's ftp server daily and load into a sql table. I want to be able to check if...
December 5, 2011 at 12:25 pm
spin (12/3/2011)
hiis it possible to get information about pc's, servers etc on my network i.e. hardware, software, computer name etc.
thanks
Yes, if there exists a user with sufficient technical know-how...
December 3, 2011 at 2:53 pm
I knew I should have 'Quoted' that to prove my sanity!
The originally posted query looked like this:
SELECT p.phoneno, mf6_telmn AS TelID, mf6_lcno AS Schedule, mf6_stad1 AS Address, StatusCd
FROM payphone p...
December 3, 2011 at 10:29 am
You have two WHEREs - the first one should be ON.
December 3, 2011 at 7:45 am
david.ostrander (12/2/2011)
My SSIS package pulls data from table (A) and inserts it into table (B) on another sql server.
Our users pull that data from table (B) into excel...
December 2, 2011 at 9:09 am
I don't understand this bit: "..pulls data like it should sho users can report off of it in excel." - is there a typo in there somewhere? It doesn't make...
December 2, 2011 at 8:50 am
What is the parent of this property - an ExecuteSQL task?
December 2, 2011 at 7:25 am
The easy way to find which column is the problem is to change the Insert statement into a Select Into using a temp table as the target, then compare the...
December 2, 2011 at 6:46 am
davidandrews13 (12/2/2011)
it runs a Stored Procedure to get back a set of data.
it then cycles through that set of data, opening a Web Service and passing the data through one...
December 2, 2011 at 5:03 am
Can you summarise what the app is supposed to do?
December 2, 2011 at 4:43 am
I think you might have more success if you create a console application to do this and then just run the .exe that that produces from within SSIS.
December 2, 2011 at 3:41 am
Please post the full text of the error message.
November 30, 2011 at 8:57 am
I know I have zero desire to code this.
That's more than I have!
November 30, 2011 at 8:36 am
jnichols-797753 (11/30/2011)
November 30, 2011 at 6:58 am
Viewing 15 posts - 10,996 through 11,010 (of 13,872 total)