Phil Parkin

Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 13,877 total)

RE: Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008.

VoldemarG - Friday, August 17, 2018 1:06 PM
So table absolutely must be pre-created?
Which is not a good option if for example a...

August 17, 2018 at 1:43 pm

#2002320
RE: Annoying error message 'Cannot drop table because table does not exist' in ExecuteSQL Task BIDS 2008.

VoldemarG - Friday, August 17, 2018 12:16 PM
It happens even though I include IF EXISTS statement before before Drop Table.
IF EXISTS...

August 17, 2018 at 12:32 pm

#2002313
RE: Convert RTF to varchar

meichmann - Friday, August 17, 2018 11:56 AM
Phil Parkin - Friday, August 17, 2018 11:50 AM

August 17, 2018 at 12:07 pm

#2002308
RE: Convert RTF to varchar

meichmann - Friday, August 17, 2018 11:37 AM
Hi Everyone,
I was wondering if anyone knew of a way to convert an RTF...

August 17, 2018 at 11:50 am

#2002304
RE: BIDS 2008 - can i insert a column into a comma-delimited flat file after it has been written to?

Jeff Moden - Friday, August 17, 2018 8:57 AM
Why not just make sure that the full monty of data is present to...

August 17, 2018 at 9:00 am

#2002272
RE: Editing SSIS packages from SQL Server 2014 with Visual Studio 2017?

bwelch42 - Thursday, August 16, 2018 2:26 PM
Should I see about updating my local SQL Server version from SS2012 to SS2014 to...

August 17, 2018 at 5:38 am

#2002211
RE: BIDS 2008 - can i insert a column into a comma-delimited flat file after it has been written to?

VoldemarG - Thursday, August 16, 2018 7:35 PM
Is it possible?
If my file has 50 columns that had been written to it by...

August 17, 2018 at 5:34 am

#2002210
RE: How to a use a temp table as a destination for a dataflow in SSIS

Chris Hurlbut - Thursday, August 16, 2018 12:45 PM
One way I do this is use a Recordset Destination (ensure the variable you...

August 16, 2018 at 12:49 pm

#2002145
RE: How to a use a temp table as a destination for a dataflow in SSIS

Thom A - Thursday, August 16, 2018 9:41 AM
Phil Parkin - Thursday, August 16, 2018 9:30 AM

August 16, 2018 at 10:16 am

#2002117
RE: Parallel SSIS processing

rocky_498 - Thursday, August 16, 2018 10:04 AM
Thanks let me test it.
However, I am stuck with, how to pass file names to...

August 16, 2018 at 10:12 am

#2002116
RE: How to a use a temp table as a destination for a dataflow in SSIS

Thom A - Thursday, August 16, 2018 9:21 AM
You could, if you wanted, create the table in tempdb. Although it's not a...

August 16, 2018 at 9:30 am

#2002100
RE: Parallel SSIS processing

rocky_498 - Thursday, August 16, 2018 8:16 AM
Yes, all are going to the same table but the different batch.
Any other better advice to...

August 16, 2018 at 8:53 am

#2002089
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 8:26 AM
This sounds...

August 16, 2018 at 8:41 am

#2002085
RE: How to a use a temp table as a destination for a dataflow in SSIS

FunkyDexter - Thursday, August 16, 2018 8:08 AM
I need to use data from one server to update a table on another server. ...

August 16, 2018 at 8:15 am

#2002074
RE: Casting string as int in derived column

david_h_edmonds - Thursday, August 16, 2018 5:55 AM
Hello, I am doing some datetime manipulations in an ssis derived column and as part...

August 16, 2018 at 6:33 am

#2002038

Viewing 15 posts - 4,141 through 4,155 (of 13,877 total)