Posted
by praveen
on Stack Overflow
See other posts from Stack Overflow
or by praveen
Published on 2010-05-29T04:37:56Z
Indexed on
2010/05/29
4:42 UTC
Read the original article
Hit count: 154
Hi all,
I need to convert the system datetime to timestamp in script task SSIS.
input date format: 29/05/2010 2:36 AM
output format: 29-15-2010 14:36:00
thanks prav
© Stack Overflow or respective owner
as seen on West-Wind
- Search for 'West-Wind'
I’ve run into the problem a few times now: How to pre-authenticate .NET WebRequest calls doing an HTTP call to the server – essentially send authentication credentials on the very first request instead of waiting for a server challenge first? At first glance this sound like it should be easy:…
>>> More
as seen on West-Wind
- Search for 'West-Wind'
Man I can't believe this. I'm still mucking around with OFX servers and it drives me absolutely crazy how some these servers are just so unbelievably misconfigured. I've recently hit three different 3 major brokerages which fail HTTP validation with bad or corrupt certificates at least according to…
>>> More
as seen on West-Wind
- Search for 'West-Wind'
The dynamic type in C# 4.0 is a welcome addition to the language. One thing I’ve been doing a lot with it is to remove explicit Reflection code that’s often necessary when you ‘dynamically’ need to walk and object hierarchy. In the past I’ve had a number of ReflectionUtils that used string based expressions…
>>> More
as seen on West-Wind
- Search for 'West-Wind'
I’ve written quite a bit about Visual FoxPro interoperating with .NET in the past both for ASP.NET interacting with Visual FoxPro COM objects as well as Visual FoxPro calling into .NET code via COM Interop. COM Interop with Visual FoxPro has a number of problems but one of them at least got a lot…
>>> More
as seen on West-Wind
- Search for 'West-Wind'
Here’s a nice and simple path utility that I’ve needed in a number of applications: I need to find a relative path based on a base path. So if I’m working in a folder called c:\temp\templates\ and I want to find a relative path for c:\temp\templates\subdir\test.txt I want to receive back subdir\test…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a Product record that has multiple "zoned" prices, one for each store that sells the product.
ProductID int
Name string
PriceA money
PriceB money
PriceC money
In SQL Server Integration Services, I need to split this in to multiple records:
ProductID int
Version string //…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
what is the use of script component in Data Flow ? Is it same as Script Task in Control flow ? Any difference ?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have an excel file. I wanted to pull the data from excel file to SQL Server table. And the data is successfully transferred.In the excel file, I removed a text from one column named "Risk" from one row.The text was lengthy one.now the package execution fails at the source ie from the excel file…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Using Script Task, I have written a code to create a folder and create a file of msword document inside the created folder. Its working in local machine. But its not working in another server, after I deployed it. The folder is created successfully, but the word document file is not created. for word…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can we abort the table post in this event:
public override void Input0_ProcessInputRow(Input0Buffer Row)
... based on an input table field condition in our SSIS Script Component?
For example
if(Row.BoolValue)
AbortPost();
We don't want to abort the whole process just this one record post…
>>> More
