Viewing 15 posts - 7,906 through 7,920 (of 11,678 total)
Here's an article on how to send an HTML formatted e-mail using SSIS:
You could create a table in HTML format and put your data in it.
February 16, 2012 at 11:21 pm
rkumar.n3 (2/16/2012)
i redirected failed record to another flat file and if i tried to load that file again, it executed successfully
Maybe the data got truncated while writing to the destination...
February 16, 2012 at 11:17 pm
A bit faster:
DECLARE @dates INT;
SET @dates = DATEPART(yyyy,'10/30/1988');
IF NOT EXISTS (SELECT 1 FROM dbo.period_dim WHERE years = @dates)
BEGIN
-- Complete SELECT statement
INSERT INTO period_dim (col1, col2, ..., coln)
SELECT ...
FROM ... ;
END
February 16, 2012 at 11:14 pm
Nice question. I immediately chose "yes", because it would have been quite sad if you couldn't force a seek somehow 🙂
February 16, 2012 at 11:07 pm
Joy Smith San (2/16/2012)
February 16, 2012 at 10:33 am
Revenant (2/16/2012)
Grant Fritchey (2/16/2012)
Stefan Krzywicki (2/16/2012)
Brandie Tarvin (2/16/2012)
February 16, 2012 at 10:31 am
But you do know Google right?
Anyway, here's a link:
http://bytes.com/topic/c-sharp/answers/268038-write-text-file-into-dataset
(Googled for .NET store file into dataset)
February 16, 2012 at 4:00 am
Koen Verbeeck (2/16/2012)
February 16, 2012 at 3:08 am
Yes. In the SSIS expression language, the \ is an escape character. Thus, if you want to have \ in your text, you need to escape it with itself, resulting...
February 16, 2012 at 1:23 am
Is something mentioned in the output window?
February 16, 2012 at 12:22 am
If you can rename the file locally, check out the File System Task.
It has the option "rename".
February 16, 2012 at 12:21 am
Phil Parkin (2/15/2012)
See the...
February 16, 2012 at 12:19 am
banu2316 (2/14/2012)
How to convert 20 jan 2012(string) into 2012-01-20 using derived column?
I wouldn't do this in SSIS. It is much much easier in TSQL as Jeff has demonstrated.
February 16, 2012 at 12:17 am
So you want a dimension just about EmployeeType?
Then indeed set the key to EmployeeType and the name also.
Discard the rest - EmployeeID and Department - as they have a...
February 16, 2012 at 12:13 am
What is the encoding of the text file?
February 16, 2012 at 12:09 am
Viewing 15 posts - 7,906 through 7,920 (of 11,678 total)