Can we use Excel file (source) for Bulk Insert Task

SQL Server Integration Services

Index ‹ SQL Server

- Previous
  - 1
    - Auto install Visual Studio is capable of deploying .Net, MSXML and SQL Express, you would use the Pre-requisites functionality (it's part of your project settings) to select which components to deploy. Management Studio is not typically deployed as part of an application so it is not set up to be deployed within VS; you have a couple of options, here they are in order of ease of implementation: Point people to the download location or include the installer on your CD and have people run it separately. Write your own Bootstrapper manifests to allow VS to deploy SSMS with a VS application. (Search MSDN for "Generic Bootstrapper" to get more information about how to do this. There is also a forum on MSDN related to VS installer technology where you can ask questions about this.) Write your own custom wrapper to chain the installation of all these components together. Mike Tag: Can we use Excel file (source) for Bulk Insert Task
  - 2
    - How do you convert SQL Server query results to Excel format and Pivot table format SQL Server does not suppport direct export to Excel, you have 3 choices; 1/ Use reporting services, generate a report that contains your query and then use Export to Excel 2/ Open the CSV in Excel using the text importer, now you get and excel sheet, save it in excel format and you should be able to do pivots based on the excel sheet data 3/ Take the query you have written and add it to an MS Query, Query in Excel and use that as a source for the pivot Tag: Can we use Excel file (source) for Bulk Insert Task
  - 3
    - connectiong to SQLServer in script component (SSIS) Dear Friend, Look at this example... and tell me if you get it... If not post here the problem and I will try to help you! Code Snippet Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports System.Data.SqlClient Public Class ScriptMain Public countErrorUsers As Integer Public Sub Main() Dim oCnn As New Data.SqlClient.SqlConnection oCnn.ConnectionString = "Data Source= SERVERNAME ;Initial Catalog= DATABASENAME ;Integrated Security=True;" Dim oCmd As SqlCommand = New SqlCommand oCmd.CommandType = Data.CommandType.StoredProcedure oCmd.CommandText = " STOREDPROCEDURENAME " oCmd.Connection = oCnn oCnn.Open() Dim oReader As SqlDataReader = oCmd.ExecuteReader() Dim strLogin As String While oReader.Read strLogin = oReader.Item(" FIELDNAME ").ToString If userValid(strLogin) = True Then ... End If End While oReader.Close() oCnn.Close() Dts.TaskResult = Dts.Results.Success End Sub Regards! Tag: Can we use Excel file (source) for Bulk Insert Task
  - 4
    - Creating a Package of dtsx packages You can't point a connection to a folder; it has to point to a package (.dtsx file). Tag: Can we use Excel file (source) for Bulk Insert Task
  - 5
    - Lookup concurrency issue in packages running simultaneously in parallel Just out of curiosity, did you copy-n-paste the lookups across the packages Are you using SQL in the lookup (you should be!) or are you simply choosing the table Tag: Can we use Excel file (source) for Bulk Insert Task
  - 6
    - getting a total from a total Aggregates over aggregates are currently not supported and are on the wish list for a next release. You need to aggregate at the dataset row level. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 7
    - order by cluase cause wrong results to be returned. In what way do you think the results are wrong Do you mean that the Themename values are not ordered correctly If so, then remember that when you have a column which has duplicate entries, there is nothing to tell sql server to output them in any particular order. You are just ordering your records based upon the value of that column ony. If you want duplicate entries to be ordered by intLocationCount, you'll need to specify that in your order clause too. Eg ORDER BY ThemeName, intLocationCount DESC HTH! Tag: Can we use Excel file (source) for Bulk Insert Task
  - 8
    - Error 87 while installing SQL Server 2005 This issue is solved. It was all about the way I burned the DVD. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 9
    - Catching Events Albertoim wrote: Hi, I'm trying to catch an error and trigger a control flow to handle it. I introduce a control flow to catch "OnError" event, but , despite muy package has some errors it doesnt work... Thanks How do you know it doesn't work Tag: Can we use Excel file (source) for Bulk Insert Task
  - 10
    - Vista SQL 2005 SP2 client to Windows XP SQL 2005 (non-sp2) workstation. Add SQL Server Management Studio to the expection list of the windows firewall on the client you're trying to connect with and that solves it. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 11
    - Trigger(its very urgent) Give a look to the TRIGGER topic in books online; there is a goodly amount of information available there that should get you off to a good start. If you do not have a copy of books online, you can download a copy from here: http://www.microsoft.com/downloads/details.aspx FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en Tag: Can we use Excel file (source) for Bulk Insert Task
  - 12
    - Cant find data source hi, have you installed SQLServerCE31-EN.msi into your development computer SDK install the msi file but not execute it. further info in http://www.microsoft.com/downloads/details.aspx familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en regards,, Tag: Can we use Excel file (source) for Bulk Insert Task
  - 13
    - Unable to Edit or Create SSIS packages or Maintenance Plans Cumulative Update 2 for SP2 addresses some maintenance plan issues. http://support.microsoft.com/kb/936305/LN/ Tag: Can we use Excel file (source) for Bulk Insert Task
  - 14
    - Select expression Type Probably you are using integer arithmetic and it is rounding to 0. try cast ((1.0 * FC2 . FCtIS / FC3 . TOTALIS ) as decimal ( 4 , 2 )) as Value Tag: Can we use Excel file (source) for Bulk Insert Task
  - 15
    - The dreaded subreport could not be shown error Make sure that the parameters you are passing are being cast correctly. If they are integers use CINT(). Everything in SRS is treated as a string initially. Hope this might help. We have several reports that use subreports and we found this to be the main problem whenever we get this error message. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 16
    - Looking for a component Matthew, I've fixed your image tags so that they display here, but unfortunately, your URL is being "cleansed" of the word, a$s. In the future, just use the tags, [i mg]URL[/i mg] (space is intentional) Tag: Can we use Excel file (source) for Bulk Insert Task
- Next
  - 1
    - Identity Primary Field in Merge Replication I wouldn;t advice you use only this for your primary key. Check out this post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1423523&SiteID=1 Tag: Can we use Excel file (source) for Bulk Insert Task
  - 2
    - An internal error occurred. [ ID = 3639 ] on delete query This error does not look like a SQL CE error. Are you using SQL CE or SQL Server Also, could you show us the statement and describe your environment, then others may be able to help you. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 3
    - JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL) Hmmm, something is still dirty on teh machine and it thinks the sql 2005 tools or the earlier 2008 tools are there, hence the "upgrade" messages. If this is a test machine and you can take some risk, and you've really uninstalled everything, make sure HKLM/Software/Microsoft/Microsoft SQL Server isn't in the registry, make sure c:\program files\microsoft sql server isn't there on the hard drive, and of course before that make sure add/remove programs shows no sql server components. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 4
    - Great New Resource for Books Online Information Hi, looks like a great job you have done. CU tosc InsideSQL.de Tag: Can we use Excel file (source) for Bulk Insert Task
  - 5
    - VERY slow stored procedure performance on datetime parameter Hi, If you use two date parameters which forms a date range, and if the first call of the SP is run with a small date range then the SP is compiled to use an execution plan which is suitable for those parameters. And after the compilation, if you give parameters that form a huge date range, that may be slow to get the results with the compiled execution plan. You may create the SP with recompile hint for such situations. But this causes the SP to be recompiled everytime it is called. Do you think this may be a reason CREATE PROC spname { parameter list } WITH RECOMPILE AS ..... Eralper http://www.kodyaz.com Tag: Can we use Excel file (source) for Bulk Insert Task
  - 6
    - query format date Try: select replace(convert(varchar(10), [date_col], 101), '/', '') as [mmddyyyy] from your_table AMB Tag: Can we use Excel file (source) for Bulk Insert Task
  - 7
    - How do i start playing with sql server??? You need to download and install the SQL Server Management Studio Express. SSMSE can be found here . A tutorial is available here . And the Books Online (the definitive learning and reference source) is available here . Referring to Books Online, refer to Topic: Walkthroughs [SQL Server...] Tag: Can we use Excel file (source) for Bulk Insert Task
  - 8
    - Foreach Loop - Value back to 0 Is the foreach loop evaluating the same variable, or are you using the variable for something else Script tasks can assign values to variables. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 9
    - How to set douplicate id in sql server 2005? Don't select the typeID column in your OLE DB destination. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 10
    - Programmatically aborting a package Are you trying to capture an error and then halt If so, there's always the FireError event that can be thrown. Tag: Can we use Excel file (source) for Bulk Insert Task
  - 11
    - SQL 2005 Management Studio Query Designer suggestions / questions No1. They are different cases. I treat it as context aware. No2. Stongly agree. it's common accepted shortcut. It should be consistent. Lots of shortcut in VS2005 are inconsistent in different versions. It's really frustrating. No8. I think the idear behind this design it just to save users' time. In most cases it actually does. And also you can easily change the connection to anyone you want. BTW: I'm curious about how could you find out so many secret shortcuts like ctrl+1, ctrl+2 ... Can it be found at the corner of some dialog or menu Thanks, Zuomin Tag: Can we use Excel file (source) for Bulk Insert Task
  - 12
    - Error on Date Data During Insert Are you sure the flat file source is mapped correctly, with correct lengths, and with a date/time format correct for DB_DBTIMESTAMP There should be other errors right next to the one you posted... Can you grab those as well Phil Tag: Can we use Excel file (source) for Bulk Insert Task
  - 13
    - Auto Filter in 2005 Reporting Services Hi, Reporting Services does not have the possibilities to do this. I think that according what you listed above you need to use a cube in case of reporting services. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: Can we use Excel file (source) for Bulk Insert Task
  - 14
    - ForEachLoop task not behaving as expected Do you have the tasks hooked together by precedence constraints (The green arrows ) Tag: Can we use Excel file (source) for Bulk Insert Task
  - 15
    - The variable "System::LocaleID" is already on the read list. What version of SQL Server 2005 RTM SP1 SP2 Tag: Can we use Excel file (source) for Bulk Insert Task
  - 16
    - Import and Export Data Wizard missing in SQL Server 2005 Express Edition Hi, BCP is documented in Books Online. SQL Express is a free product and not all features are included. In this version they removed the Import/Export wizard for a number of reasons. We're looking at alternative soluitons for a future version of SQL Express. Mike Wachal SQL Express team Tag: Can we use Excel file (source) for Bulk Insert Task

sam33r

Can an excel file be used as a source for a Bulk Insert Task in SSIS instead of a delimited flat file

Top

Re: Can we use Excel file (source) for Bulk Insert Task

MatthewRoche

I do not believe so - the Bulk Insert task uses the same API as BCP, so the limitations are the same.

You can, however, use it as the source for the data flow task, which is much more flexible and offers similarly excellent performance.

Top

Re: Can we use Excel file (source) for Bulk Insert Task

itsAshish

No you cant use excel How ever you can use flat file with format specified in a format file.

Top