.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SSIS Import - incremental file import

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :Sql Server
 

Hi

Is it possible to import an incrementing file in SSIS using a different file name each day?
For example – on Monday I want to import “file1” on Tuesday I want to import “file” and so on.

This is so I can set a package up in SQL server to run everyday using a different file.

If not, are they are similar work arounds?

Thanks,

Ant

 




View Complete Post


More Related Resource Links

Import a flat file with combined data into separate SQL tables using SSIS

  
I have a flat text file (comma delimited) that is essentially multiple files, each with its own format, combined into one file. The file is coming from an external software vendor so unfortunately we don't have much choice but to work with what we are receiving. Here is an example of what the file could look like: Customer Data CustID,FName,LName,PhNum,Email 12345,John,Smith,,jsmith@gmail.com 12346,Jane,Doe,8001111111,jdoe@hotmail.com Customer Plan CustID,PlanType,PlanName,PlanStart 12345,0,Plan1,01/01/2010 12345,2,PlanVis,01/01/2010 12346,3,PlanLf,04/01/2010 12346,0,Plan1,01/01/2010 Customer Payment CustID,LastPayment,Amount 12345,09/01/2010,100.00 12346,05/01/2010,50.00 There is an empty line between each 'section' of data. I adapted a VB script I found online that can take the incoming file and save off each section as its own file so that each one can be separately imported, but this seems inefficient. I'm really new to SSIS in general, but it seems like it shouldn't be that difficult to take the data, split it where there is an empty line, and then import each section into the appropriate SQL table. Any ideas would be most welcome. Thanks!  

Import Excel file with Data Connection into SSIS

  

I have got an Excel spreadsheet with a Data Connection that I want to import into SSIS. The problem is that the Data Connection does not seem to run at the time the file is imported, so it only calls "old" data.

How can I set SSIS up to run the Data Connection first, or is there something I need to change in my Excel spreadsheet setup?

When a person opens the Excel file normally, they first need to "Enable" the Data Connection in the Security Settings. Once that is done the data will update immediately. I wonder if that is something I somehow need to change to make it work in SSIS?


USEING SSIS PACKAGE TO IMPORT DATA FROM XML FILE

  

HI,

I want to import values of current_time, name, and age from the XML file below. Then I will export those values into sql.

by using "xml source" I can recieve values from name and age, but not from current_time.

my question is, how to get

SSIS with csv file import

  

I am importing csv file into sql server using ssis package. I have one text data type column in that csv file. I configured the source with necessary options, but i am getting the following error for the "text" data type column. Please help me asap. Thanks in advance.

***************************************************************

Error: 0xC0202055 at Data flow task, Flat File Source : The column delimiter for column "column name" was not found.

Error: 0xC0202092 at Data flow task, Flat File Source : An error occurred while processing file "**.csv" on data row 1336.

Error: 0xC0047038 at Data flow task, DTS.Pipeline: The PrimeOutput method on component "Flat File Source " (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Error: 0xC0047021 at Data flow task, DTS.Pipeline: Thread "SourceThread0" has exited with error code 0xC0047038.

Error: 0xC0047039 at Data flow task, DTS.Pipeline: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.

E

Import XML File to SQL Table

  
Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.

First, the following XML is saved to XML file C:\Products.xml.

SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

  
For whatever reason, whenever the SSIS Import/Export Wizard needs to display an error message, it throws up "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore - all cause the wizard to close. I see some activity in Process Monitor that looks like DTSWizard.exe is probing around for some System.Web assemblies, and not finding them. I'm running 2008 SP1 on Win 7 x86, and I've reinstalled the client tools and Integration Services. Anybody else seen this issue? Should I file a report on Connect?

How to import XML file with BCP?

  
I am a first time BCP user.  I have an XML file that I need to import into a new table in SQL Server.  This is using SQL Server 2008 and BCP version 10.50.16.  I read through the documentation but I get 370,000 errors!  (This is a very large file).  When I open the error log, I just see a bunch of question marks.  About this XML file: it does use a new line to delineate rows, however, it uses the space character to separate fields.  So I'm not sure if that is what causes it to fail.  The failure message is: BCP copy in failed I wish it were more descriptive.  Is there a way to get a more detailed error message? Otherwise, here is my command: d:\SQL Tables\data>bcp Development.dbo.wbl_zSkywardEnrollment2 in zSkywardEnroll ment.xml -fSE_format.fmt -m50 -eseErrorLog -b100 -t0x20 -T -F107 All of these files are in this same directory.  I know it says to specify full file path, but since they're all in this same directory and also I saw another example where they didn't specify directories I thought this would suffice. I have tried this without the format file also, doing it interactively but get same errors. And I have tried this starting with row 1.  I am curious which line should BCP start on?  Line 1 of this XML starts with Schema and ElementType info.  But on line 107 is where rs:data section

Can't import VWI file from SharePoint Designer into Visio

  
Hi,   I have Visio 2010 Premium.  Am running SharePoint 2010 Enterprise. I have created a workflow in SharePoint Designer 2010.  I select the "Export to Visio" button.  A VWI file is created. In Visio 2010, I attempt to open the file.  However, Visio reports that it cannot read the file.   Please advise.

CSV file import

  
I want to import file ( CSV ). Can any one tell me how to write a stored procedure for this purpose or any other way to import a CSV file into my database.

Text truncated to 255 using SSIS ACE.oledbprovider to import excel 2007 spreadsheet

  
Hi All, Trying to use SSIS SQL 2005 to import an Excel 2007 file (.xlsx). I'm using Office 12.0 Access Database Engine OLEDB Provider with extended properties Excel 12.0;HDR=Yes;IMEX=1 The problem is when I have text with more than 255 characters. It basically defaults the source output to Unicode string[DT_WSTR] 255, If I change it it errors out. I have done the registry change according to http://msdn.microsoft.com/en-us/library/ms141683.aspx but I think it only applies to Excel source not OleDb Source. (A Excel source does give me a text instead of string )   I have also tried to increasing the length of output such as 4000 instead of 255 but it doesn't allow either.   Anybody can help?I'm stuck for a day. Thank you very much for your help. Regards, Koala  

How to import MOD video file to windows movie maker (WMM)?

  
MOD to windows movie maker converter is one of the most efficient converting program for your to convert MOD file to windows movie maker compatible format—WMV, AVI, MPG so that you could import MOD to windows movie maker for editing MOD with WMM without difficulty. People may encounter many problems about MOD and windows movie maker •1. I have an Everio JVC hard disk drive (meaning no tape needed) and the Windows movie maker says it doesn't support "The file F:\SD_VIDEO\PRG003\MOV0CD MOD is not a supported file type, and it cannot be imported into Windows Movie Make". •2. Hey I just got this video Camera with a hard driver build in, and it makes all the movie files in MOD files, but how do I convert them so I can put them into Windows Movie maker? •3. I have MOD video files on an sd card that I am trying to open and edit with windows movie maker. It shows the video but there is no sound from the files. Please help. The main reason for movie maker not being able to recognize MOD A MOD video file is used by some models of Panasonic, JVC, Canon and perhaps other camcorders and windows movie maker does not support MOD. That is why you are having problems. Windows movie maker is quite friendly to WMV, AVI and MPG format. MOD to windows movie maker converter is the best software to change MOD files extension for importing MOD to windows movie maker Ap

How to create a SSIS package to import records form SQl Server 2008 tables to text files

  
I am a newbie to SSIS and would like to create a package to accomplish the task referenced in the above title. Will appreciate any links and pointers in the right direction.   Thanksakoranteng

Import Error: Could not process the file Documents/Application Deployment.mht as a Single File Web P

  
Hi there everyone, Version: Windows Sharepoint Services 3.0 with Cumulative Update June 29, 2010 applied. I am having issues importing an exported site into a different domain. I've overcome most of the issues and actually got most of the site to import, however, the import process get's stuck on import a Single File Web Page document from a document library. I believe the original cause of this error is http://support.microsoft.com/kb/980079 The issue I face now is, I already have a large number of .mht files in my document library which I do need to import into the test environment (or that I might need to restore in a DR scenario). Does anyone have any information on either: forcing the import commmand to "on error resume next" (ie. not stop processing when it encounters an error) fixing the already corrupt .mht files in the database easily The error text from the import command is: Error: Could not process the file Documents/Application Deployment.mht as a Single File Web Page document. at Microsoft.SharePoint.Library.SPRequest.CreateOrUpdateFileAndItem(String bstrUrl, String bstrWebRelativeUrl, Guid& docId, Object varDoc, Int32 docLength, Int32 exists, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Int32 iVersion, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String checkInComment, Int3

Has anyone tried to import an XML file generated by PPT into SQL?

  
I'm trying to take the XML that is generated by a "Save As" from PPT 2007 and import that into SQL. My goal is to be able to capture the appropriate records for the presentation, slides, and images and have them stored and accessible. When I try follow the directions found here: http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx I run into a problem that the XML contains multiple namespaces. Any help would be greatly appreciated!

SSIS Excel import skip first rows

  
Hello,1. Is it possible during import data from Excel to DB table skip first 6 rows for example?2. Also Excel data divided by sections with headers. Is it possible for example to skip every 12th row?Thank you,V. A.

Has anyone tried to import an XML file generated by PPT into SQL?

  
I'm trying to take the XML that is generated by a "Save As" from PPT 2007 and import that into SQL. My goal is to be able to capture the appropriate records for the presentation, slides, and images and have them stored and accessible. When I try follow the directions found here: http://www.sql-server-performance.com/articles/dba/Loading_XML_data_into_SQL_Server_2008_p1.aspx I run into a problem that the XML contains multiple namespaces. Any help would be greatly appreciated!

SSIS Import Package Error - DTSRuntimeWrap 0xC0010026

  
Hi, I have a problem with importing dtsx package on SSIS 2008. When I try to import this in SSIS MSDB, I have an Exception from HRESULT: 0xC0010026 (Microsoft.SqlServer.DTSRuntimeWrap). The related topic does not help me, because the package is generated in 2008 version, imported with 2008 Management Studio. Any idea? Thanks a lot, Giovanni
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend