Viewing 15 posts - 7,411 through 7,425 (of 11,678 total)
* edit: accidently posted something. Post removed. *
April 4, 2012 at 4:55 am
W00t! Steve approved my QotD on SSIS 2012. It will be published around 18th of April.
April 4, 2012 at 4:45 am
Hardy21 (4/3/2012)
I would like to know - Is SSIS Send mail use Database Mail feature only (means internally) ?
What is pros & cons to use SSIS Send...
April 4, 2012 at 4:42 am
Roy Ernest (4/3/2012)
Long time since I have been here.... Did I miss anything other than Spanish Inquisition?
Nothing that nobody would expect...
April 3, 2012 at 11:04 am
When you use the tabular models, you can still build your data warehouse using the Kimball method. Since the star schema's are relatively simple, it will be pretty straight forward...
April 3, 2012 at 9:37 am
In your explanation you never said anything about an OLE DB Destination.
I think you coupled your no match output to your updates and your match output to your inserts. It...
April 3, 2012 at 5:31 am
So you mean that there aren't any rows updated?
If you run the package, you can see how many rows were sent to the OLE DB Command.
April 3, 2012 at 4:56 am
The Kimball books are about design and architecture of a data warehouse.
They are technology independant, so it should be your first read if you really want to go into data...
April 3, 2012 at 3:54 am
abhish_216 (4/3/2012)
But i am not able to get the desired output. emptem is now empty.
emptem is the table right?
You're doing an update statement in the OLE DB command, so...
April 3, 2012 at 3:41 am
abhish_216 (4/3/2012)
i have checked the data types.empno data type is DT_I4 and ename datatype is DT-STR for the entire data flow.
All seems OK.
But there must be some sort of...
April 3, 2012 at 3:24 am
Right-click on an arrow in the dataflow, choose dataviewers and select metadata.
April 3, 2012 at 3:12 am
Duran (4/3/2012)
How was it amusing?
That's spam. I reported it 🙂
April 3, 2012 at 2:41 am
abhish_216 (4/3/2012)
What datatype is used in SSIS? ...
April 3, 2012 at 2:26 am
Are both the source and destination SQL Server?
What datatype is used in SSIS?
What collation do you use in the source and destination?
April 3, 2012 at 12:36 am
Viewing 15 posts - 7,411 through 7,425 (of 11,678 total)