
Converting a string to a integer data type in ssis
Flat file source will show that data type is DT_STR but when you will transfer into table that has 2nd column defined as integer. it will get transformed with no issue.
Using Powershell to export SQL table data to text files
I am trying to write a powershell script to export SQL table data (exact tables will be the result of a query) to individual flat files. The files must have a column heading, "|" pipe delimited. This will …
Using OPENROWSET for csv files - social.technet.microsoft.com
I suggest the Service Account User is taken to access the CSV File. If this Account does not have Access Rights to your share (or File), you cannot read the CSV File.
Hyperion (Star Analytics) - TechNet Articles - United States …
All data, metadata, supporting details and security (filters and users) from the 3 apps are re-instantiated in a variety of formats that are standards-based. Once in the star schema (or flat …
How do you restore rules and alerts from exchange 2007 backups?
Only Server Side rules can be restored even though you restore from flat file or from backup. Again you will have to activate those rules via outlook.The client side rules are stored in outlook.
Excel Destination Error: Column"xx" cannot convert between …
I too am having an issue with the file connection keeping the changes I made to the Destination columns. Any suggestions on how to keep it from changing back to string DT_STR? FYI: I am …
Exchange 2010 Database edbfile path and log folder path change
I have moved the db into its own subfolder on the volume and reconfigured exchange to use the mountpoint\subfolder path but because I had already configured drive letter access during my …
Has anyone Migrated a SCO 5 OS to #VMware4 sucessf.
Feb 3, 2010 · Has anyone Migrated a SCO 5 OS to #VMware4 sucessfully Getting error
Virtualization - VMware Technology Network VMTN
Hidden page that shows the message digest from the home page
ftp in a bat file - social.technet.microsoft.com
I will have the power-shell script write the file using appropriate parameters for filename and connectivity. run it. and then delete it. can someone help me script this. so far my attempts at …