I am loading data in to Sharepoint List and I am getting the below error message. I was able to load data yesterday to same list and then deleted the data. I am trying to reload the data now and …
under "Creating a new project"
The second picture, under the line starting …
I am creating a SSIS package to generate .CSV files. But I came to know that we have constraint in Microsoft Dynamic CRM i.e. the .csv file size should not greater than 8MB.
I might have …
Where do I go to upgrade my SSIS package, can't seem to find the button? See the attached picture.
Any assistance is appreciated.
I am trying to import only the new records from my Access database table to a Table on my SQL server using SSIS. The process errors out and halts the first time it encounters a duplicate PK. How can I…
Hello Experts Exchange
I am developing a Finance cube, I'm trying to mimic the same functionality as SAP BPC.
In Excel the users look at the data in the SAP BPC cube and can view and update the …
In VS 2013
When I click on the Start menu button
The process runs fine and steps through each "node"
Is there a way... since I need to demo this and explain what is going on...
To "Pause" at …
On an AWS EC2 server (Windows Server)
I need to set a once a day task to run a DTS Package.
I have a data flow in my SSIS.
In the attached image the flow on the left is disabled
In the center dataflow.... the failure if it happens will 99% of the time be on the Send Data to Server section.…
I am trying to use Merge Join and Conditional Split to update my postcode table with lat/long. Below is my query from source table
I am selecting the top 1000 just for testing …
I need to do data migration, the input would be .csv or excel file(s).
What would you prefer?
1. Import Wizard
What are the pros & cons for both approaches?
Is there any …
In my SSIS I have a connection to a remote server
I also have a "datatable" source that I need to feed 1 records at a time into that stored procedure.
Select InternalID, FirstName, …
Trying to replace a SQL statement in an SSIS module, but I am getting the attached error message.
Here is the query in total:
How would resolve this error any assistance is …
In order to remove snowflake dimensions from a star data warehouse schema, I would like to flatten the hierarchies so that I can then load the data into a dimension.
The tables that are …
How could I go back a fiscal year for a given date?
My organization use the format of the Fiscal year as follows:
'FY2015', 'FY2016', 'FY2017'
I need to get these values automatically using …
I have an SSIS 2012 package that loops through files using a for each loop and loads data into a table.
However, I'd need to handle a couple a scenarios that I'd need to take care of in the …
Are ssis dynamic queries reliable?
I have an Ssis package say abc.dtsx,that loops through files and performs a few validations using Ssis tasks such as Execute SQL task,etc.
After the for each loop is executed, I have an …
I have read-only access to a database (eg DB1) via MS SQL Server Management Studio (SSMS). I created an SSIS package in Visual Studio that exports all the tables in the database, DB1, to Excel. Now, …
Hi, I am exporting some data to excel using SSIS.
I have a datetime field in my sql server 2008 DB showing as '2009-05-27 16:09:00.000'
but after the data is exported to Excel using SSIS the …
I am a total C# neophyte. The last time I code in C was in 1995 and that was just for a computer class. I can read code a little but need help in deciphering just what this block of code…
how to upgrade SSIS from SQL 2008 to SQL 2014/2016.
From my experience for all SQL server upgrade project I done myself which has no problem, SSIS package always no problem, but when SQL server …
What data flow task would i use in SSIS to return the results of a function? I will need to pass in a varchar value which will return a varchar value
I have a field Accept_Referral
IF the value is 'yes' in want the derived column to return 1
if no the derived column should be 0
if null then just leave it as null
I need to build a SSIS that
Connects a VPN
Then establishes a .net SQL Server connection string through the vpn connection.