Viewing 15 posts - 46 through 60 (of 641 total)
That's awesome you did that. I've opened it and I will try it today.
January 22, 2015 at 1:09 pm
Yes, I thank you but like you say it's probably overkill. I have to learn C# for making the most of the script task transformation (Control Flow).
See here, 'How...
January 22, 2015 at 7:05 am
Koen, I followed what you were saying and that sounds very good. I will try that today. thanks very much.
twin.devil, Actually, suggestion one is viable but it requires a lot...
January 19, 2015 at 5:20 am
well, those are not exactly helpful.
The first link is a tutorial for how to set up a flat file connection (which I have already done) and while the second is...
January 18, 2015 at 3:33 pm
there is no transformation that allows me to run the select statement I mentioned against the flat file source connection.
Perhaps you can elaborate "go from there"....as I see it the...
January 15, 2015 at 10:19 pm
I have fumbled around with this and reverted to an older package that used 7zip.exe....and restarted development forward. This approach 'resolved' this particular problem which was preventing overall progress...
January 14, 2015 at 7:01 am
sorry, got it
IF object_id('dbo.TESTTABLE') is null
begin
SELECT TOP(0) * INTO dbo.TESTTABLE FROM dbo.ORIGINALTABLE
END;
January 4, 2015 at 5:51 pm
the only available 7z for command line is for 32-bit
http://7-zip.org/download.html
I have 64 bit system. Does it matter?
January 4, 2015 at 4:51 pm
ok, thanks. that gives me some new angles ie. redirecting to log and using 7za.exe instead of 7z.exe. So, 7za.exe is important? As is the unzipping is happening from...
January 4, 2015 at 4:49 pm
1. Are there many remote locations or is there only one (for each SSIS package)?
2. Is the local directory emptied after processing the files?
Answers:
1: one remote location for the SSIS...
January 4, 2015 at 9:01 am
i saw option to save as ssis package. examined it and found source text was importing keyword_id as string.
what I was doing in SSIS when the duplicates were happening was...
January 1, 2015 at 12:46 am
Well I never! I will take a look at import wizard with new eyes as soon as in office. Btw, keyword id column is float in source column and...
December 31, 2014 at 10:40 am
...:w00t:
December 31, 2014 at 10:39 am
It sounds promising but I don't understand
"If you edit both packages side by side, there will be a difference in the way that the import wizard performs the import...
December 31, 2014 at 9:21 am
I don't understand "saving the SSIS package produced by the import wizard"
the process of importing these files needs to be automated. Therefore, the object of the ssis package is not...
December 31, 2014 at 9:02 am
Viewing 15 posts - 46 through 60 (of 641 total)