Viewing 15 posts - 3,256 through 3,270 (of 9,720 total)
Does it have to be Replication or can you just use SSIS to grab the data and move it into SQL that way?
April 18, 2014 at 5:25 am
Actually, it just occurs to me... Can I use WebClient.UploadFile method with this code? Do I have to create a physical file for this or can I just stream it...
April 18, 2014 at 5:24 am
BRILLIANT!
That's exactly what I needed. I thought I had to load the file into Powershell before playing with it (ala a temp table).
Thank you. Now I just have to figure...
April 18, 2014 at 4:32 am
FYI: Followup Powershell question at http://www.sqlservercentral.com/Forums/Topic1562838-1351-1.aspx
If I weren't on a deadline of three days ago, this wouldn't be so hard and I'd already have my answer. I just know it......
April 17, 2014 at 1:49 pm
That is a good point that I didn't think fully through. Thank you for the reminder.
There's got to be a better way for the users to get what they need,...
April 17, 2014 at 9:00 am
kbnyny (4/17/2014)
Brandie when I took out he Binary Base64 I still get the same funny character on the XML output file.
Can you give us a DDL for the table and...
April 17, 2014 at 8:50 am
Hmm. I'm not able to replicate the strange character pattern on my flat file. It comes out as all binary. And when changing datatypes in the connection manager, I appear...
April 17, 2014 at 5:15 am
I am trying to replicate this in my environment, using my own tables. Can you post the set up of the flat file connection manager (General and Advanced tabs)?
You can...
April 17, 2014 at 4:47 am
kbnyny (4/16/2014)
When I change encoding to unicode and the data type DT_NTEXT to that this is...
April 16, 2014 at 3:25 pm
Can you add it to your post as an attachment instead of embedded into the post? All I can see is a place holder and I've used 2 different computers...
April 16, 2014 at 3:10 pm
kbnyny (4/16/2014)
April 16, 2014 at 2:49 pm
kbnyny (4/16/2014)
The Data type is the same in the connection manager and in the Data Conversion Transformation Editior.
That's not what I asked. You said you were having problems changing the...
April 16, 2014 at 12:34 pm
Your XML document may be malformed. Are you sure you have your hierarchy designed correctly?
And are you looking for a full XML document or just a fragment?
EDIT: Are you changing...
April 16, 2014 at 12:17 pm
Another question. Once I finish writing up the Powershell script, how do I make it part of the SSIS package or the SQL Server Agent job?
Is it as simple as...
April 16, 2014 at 11:53 am
Viewing 15 posts - 3,256 through 3,270 (of 9,720 total)